home *** CD-ROM | disk | FTP | other *** search
/ Shareware Overload Trio 2 / Shareware Overload Trio Volume 2 (Chestnut CD-ROM).ISO / dir43 / qsrc_dsk.zip / MODEL / BUDGET1.QPR < prev    next >
Text File  |  1992-01-13  |  1KB  |  22 lines
  1. *       ╓─────────────────────────────────────────────────────────╖
  2. *       ║                                                         ║
  3. *       ║ BUDGET1.QPR                                             ║
  4. *       ║                                                         ║
  5. *       ╟─────────────────────────────────────────────────────────╢
  6. *       ║ Application Developed in _Using FoxPro 2_               ║
  7. *       ║                                                         ║
  8. *       ║ Lisa C. Slater and Steven E. Arnott                     ║
  9. *       ║                                                         ║
  10. *       ║ Copyright (c) 1991 Que Publishing                       ║
  11. *       ║                                                         ║
  12. *       ╙─────────────────────────────────────────────────────────╜
  13.  
  14.  
  15. SELECT DEPT.DEPTNAME, BUDGET.PERIOD, SUM(BUDGET.BUDGETAMT);
  16.  FROM BUDGET, DEPT;
  17.  WHERE DEPT.DEPTCODE = BUDGET.DEPTCODE;
  18.  GROUP BY BUDGET.PERIOD, BUDGET.DEPTCODE;
  19.  HAVING BUDGET.PERIOD=M.PERIOD;
  20.  ORDER BY BUDGET.PERIOD;
  21.  INTO CURSOR query1
  22.